<?php
date_default_timezone_set('Asia/Shanghai');//时区配置
$conn=mysql_connect("121.37.61.76","YuanChengG","idcnYancq4");
mysql_select_db("new_gsdai", $conn);
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $conn);

//ych_account_log_0
$decrtime = 3600*8;
$time = strtotime('2014-01-02 12:00:00');
for ($i=0;$i<100;$i++){
	$table = "ych_account_log_".$i;
	$sql = "update $table set add_time=add_time-$decrtime where add_time>$time";
	mysql_query($sql,$conn);
}

?>